package com.lecture.java8.excel.a0210;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

/**
 * 第二个excel和模板中的第三个sheet页，输出明细-签约额
 * @author luyn
 * @date 2025/02/11
 */
@Data
public class Entity2 {

    @ExcelProperty({"合同概况","地市"})
    private String city;

    @ExcelProperty({"合同概况","区县"})
    private String district;

    @ExcelProperty({"合同概况","项目名称"})
    private String projectName;

    @ExcelProperty({"合同概况","项目编码"})
    private String projectCode;

    @ExcelProperty({"合同概况","省内商机编码"})
    private String provincialOpportunityCode;

    @ExcelProperty({"合同概况","前向合同编码(客户-ICT,客户-移动)"})
    private String forwardContractCode;

    @ExcelProperty({"合同概况","合同名称"})
    private String contractName;

    @ExcelProperty({"合同概况","签约日期"})
    private String signingDate;

    @ExcelProperty({"合同概况","签约额(元)"})
    private Double contractAmount;

    @ExcelProperty({"合同概况","出账计划金额(元)"})
    private String billingPlanAmount;

    @ExcelProperty({"合同概况","行业"})
    private String industry;

    @ExcelProperty({"非主营收入","设备收入(元)"})
    private String equipmentRevenue;

    @ExcelProperty({"非主营收入","建安收入(元)"})
    private String constructionRevenue;

    @ExcelProperty({"集成维保收入","ICT-传统项目(元)"})
    private Double ictTraditionalRevenue;

    @ExcelProperty({"集成维保收入","ICT-云计算/定制云(元)"})
    private Double ictCloudRevenue;

    @ExcelProperty({"集成维保收入","ICT-5G(元)"})
    private Double ict5GRevenue;

    @ExcelProperty({"集成维保收入","ICT-AI(元)"})
    private Double ictAIRevenue;

    @ExcelProperty({"集成维保收入","ICT-大数据(元)"})
    private Double ictBigDataRevenue;

    @ExcelProperty({"集成维保收入","ICT-9one(元)"})
    private Double ict9oneRevenue;

    @ExcelProperty({"集成维保收入","ICT-安全集成费(元)"})
    private Double ictSecurityIntegrationFee;

    @ExcelProperty({"集成维保收入","手续费(元)"})
    private Double handlingFee;

    @ExcelProperty(value = {"集成维保收入","其它(元)"},index = 21)
    private Double otherRevenue;

    @ExcelProperty({"CT业务收入","专线(元)"})
    private Double dedicatedLineRevenue;

    @ExcelProperty({"CT业务收入","5G(元)"})
    private Double revenue5G;

    @ExcelProperty({"CT业务收入","公有云(元)"})
    private Double publicCloudRevenue;

    @ExcelProperty({"CT业务收入","大数据/AI(元)"})
    private Double bigDataAIRevenue;

    @ExcelProperty(value = {"CT业务收入","其它(元)"},index = 26)
    private Double otherCategoryRevenue;

    @ExcelProperty({"其它收入","受托代销收入(元)"})
    private Double entrustedAgencyRevenue;

    @ExcelProperty({"其它收入","代收代付收入(元)"})
    private String collectionPaymentRevenue;

    @ExcelProperty("IT通服签约额")
    private Double itServiceContractAmount;

    @ExcelProperty("信息化收入")
    private Double digitalizationRevenue;

    @ExcelProperty("客户单位")
    private String customerUnit;

    @ExcelProperty("集团客户编码")
    private String corporateCustomerCode;

    @ExcelProperty("客户经理")
    private String customerManager;

    @ExcelProperty("总收入")
    private Double totalRevenue;

    @ExcelProperty("总支出")
    private Double totalExpenditure;

    @ExcelProperty("毛利率")
    private String grossProfitMargin;

    @ExcelProperty("CT收入")
    private Double ctRevenue;
}
